<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<!-- 



*************  커뮤니티 hot_girl_board  *************

create table board_hot_girl(BOARD_NUM number,
BOARD_NAME varchar2(20),
BOARD_PASS varchar2(20),
BOARD_SUBJECT varchar2(100),
BOARD_CONTENT varchar2(4000),
BOARD_FILE varchar2(4000),
BOARD_COUNT number,
BOARD_RE_REF number,
BOARD_RE_LEV number,
BOARD_RE_SEQ number ,
BOARD_READCOUNT number,
BOARD_DATE date)


 ************** 제안  offer_board *****************
create table offer_board(
num number,
writer varchar2(20),
style_type varchar2(100),
product_num varchar2(100),
cody01 varchar2(100),
cody02 varchar2(100),
cody03 varchar2(100),
board_file varchar2(500),
tags varchar2(500),
reg_date date)

 ************** shop(상품 등록) shop_board *****************
create table shop_board(
num number,
leve number,
writer varchar2(20),
cate_type varchar2(100),
product_num varchar2(100),
cody01 varchar2(100),
cody02 varchar2(100),
cody03 varchar2(100),
title varchar2(400),
product_size varchar2(100),
product_color varchar2(100),
price varchar2(100),
board_file varchar2(500),
tags varchar2(500),
reg_date date)

***********   로그인     SHOP_MEMBER  ************

CREATE TABLE SHOP_MEMBER(
	SHOP_ID VARCHAR2(20),
	SHOP_NAME VARCHAR2(20),
	SHOP_PSWD VARCHAR2(15),
	SHOP_BIR_Y INT,
	SHOP_BIR_M INT,
	SHOP_BIR_D INT,
	SHOP_SEX VARCHAR2(20),
	SHOP_MAIL VARCHAR2(25),
	SHOP_MAIL_SERVICE VARCHAR2(13),
        SHOP_PHON VARCHAR2(13),
	SHOP_ZIPCODE VARCHAR2(40),
	SHOP_ADD01 VARCHAR2(70),
	SHOP_ADD02 VARCHAR2(70),
	SHOP_DATE DATE
);

************카트 Basket*************

CREATE TABLE BASKET(
 BASKET_PRODUCT_NUM INT, 
 SHOP_ID VARCHAR2(20), 
 PRODUCT_NUM varchar2(100), 
 CATE_TYPE VARCHAR2(100),
 BOARD_FILE VARCHAR2(500), 
 AMOUNT INT,
 PRODUCT_SIZE VARCHAR2(100), 
 PRODUCT_COLOR VARCHAR2(100), 
 PRICE varchar2(100), 
 BASKET_DATE DATE, 
 PRIMARY KEY(BASKET_PRODUCT_NUM) 
);

 -->
</body>
</html>